UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgTEFa0PNzcT58+IVex3RipUn1UeBnBM9tliZU/xwJw='
WHERE
key_id = 'd8faca015123a7eb0f4e6c989c6ad819a85a72ef86398b3d9adcd166d91193ce'
AND (
token = 'rgTEFa0PNzcT58+IVex3RipUn1UeBnBM9tliZU/xwJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)