UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1VhASJtjlF1h5YLOuSUIAv5Jrcjnrv2gA64VWUaRIc='
WHERE
key_id = '5a831ca62e313a1218a5292d6d7a66e6df6eac931ad7039a8e283eed1782baf9'
AND (
token = 'b1VhASJtjlF1h5YLOuSUIAv5Jrcjnrv2gA64VWUaRIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)