UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kmibIEpD7iseJCRtw96BHmUOfwQbGo6RjheCz/zRgRA='
WHERE
key_id = '4b2016a8df67531671c9856dddaacd2be29c956368112cd197da76834a419959'
AND (
token = 'kmibIEpD7iseJCRtw96BHmUOfwQbGo6RjheCz/zRgRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)