UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWF6ulkAr4VG+FqfjkukoWySwRZP0DpNpz8mHKtBHO0='
WHERE
key_id = 'ecf1b3acbcd1bc555f0e9a5a752240ddf71a08def5ee031fcee58143c7e859a5'
AND (
token = 'bWF6ulkAr4VG+FqfjkukoWySwRZP0DpNpz8mHKtBHO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)