UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7dP/mfG2TgEpTE3ecHi5WQLEuwvfafi7/TVwhZvYJw='
WHERE
key_id = 'b515a4bd778965ab5d58ca9c1b924e537078c4b883f3d9c8213a45140d608a34'
AND (
token = 'p7dP/mfG2TgEpTE3ecHi5WQLEuwvfafi7/TVwhZvYJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)