UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHQxChpd6H1sd6htn4GDfUyJXvbBtjTIFFySgR+58mc='
WHERE
key_id = '6eacac82940f09b7b119e4a79d0b69c1e9ebde67c851fa3c92321f3a149e6de0'
AND (
token = 'oHQxChpd6H1sd6htn4GDfUyJXvbBtjTIFFySgR+58mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)