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