UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJnIdh8mtiobUvZu/azO8owcliui4Gd+B71EQ4aK/LQ='
WHERE
key_id = '6a4109b09e6d12954ed3831620daa4dca02e900b8c980cc1d826ee969bbb8138'
AND (
token = 'dJnIdh8mtiobUvZu/azO8owcliui4Gd+B71EQ4aK/LQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)