UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bRVQdqP9GqH1gxudwieYyCYVH4ljRxMnee0eOO2+jpA='
WHERE
key_id = 'a1fa64d4ec03f25355331e133b82a0e696ee81d676da3070434765354eb85fd7'
AND (
token = 'bRVQdqP9GqH1gxudwieYyCYVH4ljRxMnee0eOO2+jpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)